package com.offcn.dongyimai.sellergoods.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.offcn.dongyimai.sellergoods.pojo.ItemCat;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/****
 * @Author:ujiuye
 * @Description:ItemCat的Dao
 * @Date 2021/2/1 14:19
 *****/
public interface ItemCatMapper extends BaseMapper<ItemCat> {

    @Select("select c.type_id as typeId,t.name from tb_item_cat c inner join tb_type_template t " +
            "where c.type_id = t.id group by t.name")
    List<Map> selectTypeIdByName();

}
